Connect to your Master Calendar using Active Directory

1. Verify that all the prerequisites are fulfilled.

   • A Master Calendar-specific Active Directory security group that contains all Master Calendar users.

   • A Master Calendar-specific Active Directory user account that exists within the above group, which will be used for authentication.

   • An installation of Master Calendar on the web server.

2. Create the new user in SQL Server Management Studio.

   1. Navigate to Master Calendar Database -> Security -> Users.

   2. Create a new user.

   3. Right-click the user and select Properties.

   4. On the General page, leave the default schema MC_User selected.

   5. On the Owned Schemas page, select the MC_User schema.

   6. On the Membership page, select db_datareader and db_datawriter.

   7. On the Securables page, select Grant for Execute for all Stored Procedures.

      For all scalar functions see the script document MCUserSP.txt to execute against the Master Calendar database in SQL. References to MC_User in this script will need to be changed to the name of this new Master Calendar user.

   8. On the Extended Properties page, leave the defaults.

3. Map the Active Directory user account to Master Calendar.

   1. Navigate to Databases -> Security -> Logins.

   2. Right-click the login and select Properties.

   3. On the User Mapping page, select the Master Calendar database.

4. On the web server, ensure Master Calendar is assigned to its own application pool in IIS.

   To ensure that Master Calendar is assigned to its own application pool in IIS:

   1. Select Master Calendar and Basic Settings on the right side of IIS to verify the assigned application pool.

      If a new application pool is needed, click the Select button.

   2. Right-click the Master Calendar application pool and select Advanced Settings.

   3. Under Process Model, click the ellipsis next to ApplicationPoolIdentity.

   4. Select and set the Custom Account field.

   5. Enter the credentials for the Master Calendar Active Directory user account.

5. Modify the Master Calendar web.config file.

   1. In IIS right-click Master Calendar and choose Explore.

   2. Open the web.config file in this directory using Notepad and make these changes:

      • Under <connectionStrings>, replace the line <add name="deaConnection" providerName="System.Data.SqlClient" connectionString="server=servername;database=MasterCalendarDBName/> with

        <add name="deaConnection" providerName="System.Data.SqlClient" connectionString="server=servername;database=MasterCalendarDBName;Trusted_Connection=yes"/>

      • Under <dataConfiguration>, replace the line <add name="deaConnection" useMCUser="true" useDetailedLogging="true" defaultCommandTimeout="120"/> with

        <add name="deaConnection" useMCUser="false" useDetailedLogging="true" defaultCommandTimeout="120"/>

   3. Save and close the web.config file.

6. Verify that the connection to Master Calendar is successful.

   1. Browse to Master Calendar from IIS.
   2. Verify that the connection is successful.